﻿using System.Linq.Expressions;
using Bing.Data.Queries;

namespace Bing.Data.Sql.Builders;

/// <summary>
/// Where子句
/// </summary>
public interface IWhereClause : ICondition
{
    /// <summary>
    /// 克隆
    /// </summary>
    /// <param name="builder">Sql生成器</param>
    /// <param name="register">实体别名注册器</param>
    /// <param name="parameterManager">参数管理器</param>
    /// <returns></returns>
    IWhereClause Clone(ISqlBuilder builder, IEntityAliasRegister register, IParameterManager parameterManager);

    /// <summary>
    /// And连接条件
    /// </summary>
    /// <param name="condition">查询条件</param>
    void And(ICondition condition);

    /// <summary>
    /// Or连接条件
    /// </summary>
    /// <param name="condition">查询条件</param>
    void Or(ICondition condition);

    /// <summary>
    /// Or连接条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="conditions">查询条件</param>
    void Or<TEntity>(params Expression<Func<TEntity, bool>>[] conditions);

    /// <summary>
    /// Or连接条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="conditions">查询条件</param>
    void OrIfNotEmpty<TEntity>(params Expression<Func<TEntity, bool>>[] conditions);

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <param name="condition">查询条件</param>
    void Where(ICondition condition);

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="value">值</param>
    /// <param name="operator">运算符</param>
    void Where(string column, object value, Operator @operator = Operator.Equal);

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="value">值</param>
    /// <param name="operator">运算符</param>
    void Where<TEntity>(Expression<Func<TEntity, object>> expression, object value,
        Operator @operator = Operator.Equal) where TEntity : class;

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">查询条件表达式</param>
    void Where<TEntity>(Expression<Func<TEntity, bool>> expression) where TEntity : class;

    /// <summary>
    /// 设置子查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="builder">子查询Sql生成器</param>
    /// <param name="operator">运算符</param>
    void Where(string column, ISqlBuilder builder, Operator @operator = Operator.Equal);

    /// <summary>
    /// 设置子查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="builder">子查询Sql生成器</param>
    /// <param name="operator">运算符</param>
    void Where<TEntity>(Expression<Func<TEntity, object>> expression, ISqlBuilder builder,
        Operator @operator = Operator.Equal) where TEntity : class;

    /// <summary>
    /// 设置子查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="action">子查询操作</param>
    /// <param name="operator">运算符</param>
    void Where(string column, Action<ISqlBuilder> action, Operator @operator = Operator.Equal);

    /// <summary>
    /// 设置子查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="action">子查询操作</param>
    /// <param name="operator">运算符</param>
    void Where<TEntity>(Expression<Func<TEntity, object>> expression, Action<ISqlBuilder> action,
        Operator @operator = Operator.Equal) where TEntity : class;

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="value">值，如果该值为空，则忽略该查询条件</param>
    /// <param name="operator">运算符</param>
    void WhereIfNotEmpty(string column, object value, Operator @operator = Operator.Equal);

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="value">值，如果该值为空，则忽略该查询条件</param>
    /// <param name="operator">运算符</param>
    void WhereIfNotEmpty<TEntity>(Expression<Func<TEntity, object>> expression, object value,
        Operator @operator = Operator.Equal) where TEntity : class;

    /// <summary>
    /// 设置查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">查询条件表达式，如果参数值为空，则忽略该查询条件</param>
    void WhereIfNotEmpty<TEntity>(Expression<Func<TEntity, bool>> expression) where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between<TEntity>(Expression<Func<TEntity, object>> expression, int? min, int? max, Boundary boundary)
        where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between<TEntity>(Expression<Func<TEntity, object>> expression, long? min, long? max, Boundary boundary)
        where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between<TEntity>(Expression<Func<TEntity, object>> expression, float? min, float? max, Boundary boundary)
        where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between<TEntity>(Expression<Func<TEntity, object>> expression, double? min, double? max, Boundary boundary)
        where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between<TEntity>(Expression<Func<TEntity, object>> expression, decimal? min, decimal? max, Boundary boundary)
        where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="includeTime">是否包含时间</param>
    /// <param name="boundary">包含边界</param>
    void Between<TEntity>(Expression<Func<TEntity, object>> expression, DateTime? min, DateTime? max, bool includeTime, Boundary? boundary)
        where TEntity : class;

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between(string column, int? min, int? max, Boundary boundary);

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between(string column, long? min, long? max, Boundary boundary);

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between(string column, float? min, float? max, Boundary boundary);

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between(string column, double? min, double? max, Boundary boundary);

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="boundary">包含边界</param>
    void Between(string column, decimal? min, decimal? max, Boundary boundary);

    /// <summary>
    /// 添加范围查询条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="min">最小值</param>
    /// <param name="max">最大值</param>
    /// <param name="includeTime">是否包含时间</param>
    /// <param name="boundary">包含边界</param>
    void Between(string column, DateTime? min, DateTime? max, bool includeTime, Boundary? boundary);

    /// <summary>
    /// 设置Is Null条件
    /// </summary>
    /// <param name="column">列名</param>
    void IsNull(string column);

    /// <summary>
    /// 设置Is Null条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    void IsNull<TEntity>(Expression<Func<TEntity, object>> expression) where TEntity : class;

    /// <summary>
    /// 设置Is Not Null条件
    /// </summary>
    /// <param name="column">列名</param>
    void IsNotNull(string column);

    /// <summary>
    /// 设置Is Not Null条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    void IsNotNull<TEntity>(Expression<Func<TEntity, object>> expression) where TEntity : class;

    /// <summary>
    /// 设置空条件
    /// </summary>
    /// <param name="column">列名</param>
    void IsEmpty(string column);

    /// <summary>
    /// 设置空条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    void IsEmpty<TEntity>(Expression<Func<TEntity, object>> expression) where TEntity : class;

    /// <summary>
    /// 设置非空条件
    /// </summary>
    /// <param name="column">列名</param>
    void IsNotEmpty(string column);

    /// <summary>
    /// 设置非空条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    void IsNotEmpty<TEntity>(Expression<Func<TEntity, object>> expression) where TEntity : class;

    /// <summary>
    /// 设置In条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="values">值集合</param>
    void In(string column, IEnumerable<object> values);

    /// <summary>
    /// 设置In条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="values">值集合</param>
    void In<TEntity>(Expression<Func<TEntity, object>> expression, IEnumerable<object> values)
        where TEntity : class;

    /// <summary>
    /// 设置In条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="builder">Sql生成器</param>
    void In(string column, ISqlBuilder builder);

    /// <summary>
    /// 设置In条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="builder">Sql生成器</param>
    void In<TEntity>(Expression<Func<TEntity, object>> expression, ISqlBuilder builder);

    /// <summary>
    /// 设置In条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="action">子查询操作</param>
    void In(string column, Action<ISqlBuilder> action);

    /// <summary>
    /// 设置In条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="action">子查询操作</param>
    void In<TEntity>(Expression<Func<TEntity, object>> expression, Action<ISqlBuilder> action);

    /// <summary>
    /// 设置Not In条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="values">值集合</param>
    void NotIn(string column, IEnumerable<object> values);

    /// <summary>
    /// 设置Not In条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="values">值集合</param>
    void NotIn<TEntity>(Expression<Func<TEntity, object>> expression, IEnumerable<object> values)
        where TEntity : class;

    /// <summary>
    /// 设置Not In条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="builder">Sql生成器</param>
    void NotIn(string column, ISqlBuilder builder);

    /// <summary>
    /// 设置Not In条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="builder">Sql生成器</param>
    void NotIn<TEntity>(Expression<Func<TEntity, object>> expression, ISqlBuilder builder);

    /// <summary>
    /// 设置Not In条件
    /// </summary>
    /// <param name="column">列名</param>
    /// <param name="action">子查询操作</param>
    void NotIn(string column, Action<ISqlBuilder> action);

    /// <summary>
    /// 设置Not In条件
    /// </summary>
    /// <typeparam name="TEntity">实体类型</typeparam>
    /// <param name="expression">列名表达式</param>
    /// <param name="action">子查询操作</param>
    void NotIn<TEntity>(Expression<Func<TEntity, object>> expression, Action<ISqlBuilder> action);

    /// <summary>
    /// 设置Exists条件
    /// </summary>
    /// <param name="builder">Sql生成器</param>
    void Exists(ISqlBuilder builder);

    /// <summary>
    /// 设置Exists条件
    /// </summary>
    /// <param name="action">子查询操作</param>
    void Exists(Action<ISqlBuilder> action);

    /// <summary>
    /// 设置Not Exists条件
    /// </summary>
    /// <param name="builder">Sql生成器</param>
    void NotExists(ISqlBuilder builder);

    /// <summary>
    /// 设置Not Exists条件
    /// </summary>
    /// <param name="action">子查询操作</param>
    void NotExists(Action<ISqlBuilder> action);

    /// <summary>
    /// 添加到Where子句
    /// </summary>
    /// <param name="sql">Sql语句</param>
    void AppendSql(string sql);

    /// <summary>
    /// 输出Sql
    /// </summary>
    string ToSql();
}
